UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qXfqu45kBqBi0NRcARrL+oRcySwXrJRkNDgdcMogZo8='
WHERE
key_id = 'bfd74d2b02fbcfcbfaa48d96f27441b47bce0dbc450e1efa0e9503e11f0c14c6'
AND (
token = 'qXfqu45kBqBi0NRcARrL+oRcySwXrJRkNDgdcMogZo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)