UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wRksYXGLCi/EUb7NxAsRgs3aOeaHUibhcDvYQmJDC5A='
WHERE
key_id = 'e24419b4ea81d14c8355fa2777594b2e5db9461e6c751e514f1101dfe87b8172'
AND (
token = 'wRksYXGLCi/EUb7NxAsRgs3aOeaHUibhcDvYQmJDC5A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)