UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r5skWfchoSYgWNwHZoHoeYsLcGYYSMlbe0RnkCND6U8='
WHERE
key_id = 'b1c4f26c2fd5cbb9a47ee4e2e277a14397ce4d3712bb1c82b86cff071ff58d2b'
AND (
token = 'r5skWfchoSYgWNwHZoHoeYsLcGYYSMlbe0RnkCND6U8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)