UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nq1b3ub8f32mxgo1JcK9hUwScSbAkhEm6eszaFkUnsM='
WHERE
key_id = '6144d9f78b0c5008ecec33ae3e61fb2d305062ff8e628c0f6baff9a2a70ffe5e'
AND (
token = 'nq1b3ub8f32mxgo1JcK9hUwScSbAkhEm6eszaFkUnsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)