UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NJ9IrrcuydJ1uq80n+D0Br+WQHlVqrsRbtZBQB2G+CY='
WHERE
key_id = 'a8144a14553bf11c08f7bf87be236bccb532bb9d44d5bd9196baa06a83172a48'
AND (
token = 'NJ9IrrcuydJ1uq80n+D0Br+WQHlVqrsRbtZBQB2G+CY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)