UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hR0S7emEZwdxyFA3Llvg3wsizWaKnF9WmKr07bYQgho='
WHERE
key_id = '42e43e42e1e277bee22c1be1434007f34a13b9ec82f5593f7dd63e12e189178f'
AND (
token = 'hR0S7emEZwdxyFA3Llvg3wsizWaKnF9WmKr07bYQgho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)