UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CItrukdFc5pTeCH0bpMNzU7w6i9w7BtgYLM+qhiCkvw='
WHERE
key_id = '9c4f9d22fbd4b6309a5c44fd808a74d08109f7703983a1b14fb67aade2989ab9'
AND (
token = 'CItrukdFc5pTeCH0bpMNzU7w6i9w7BtgYLM+qhiCkvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)