UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'usJVDYd0u78YxnEOVsN9yg7DOwFSfe6ElM7+K7dxUK8='
WHERE
key_id = '59e06e6014878bebc6c657098ab8fedb855b07322f32805a5b1297f3d1e67855'
AND (
token = 'usJVDYd0u78YxnEOVsN9yg7DOwFSfe6ElM7+K7dxUK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)