UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm8oHJpYhyWGPJ2TKk61qlJW+9q4384wtl+vBYUt/qVg='
WHERE
key_id = 'bccaaeee441508e1485ea1dcad98f1b527bf175100ebca4f0928c1d8fa04987c'
AND (
token = 'm8oHJpYhyWGPJ2TKk61qlJW+9q4384wtl+vBYUt/qVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)