UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xuZXagEc38/RXluAmfPIYFQU9GtY8RcQjD3bf5gz0gg='
WHERE
key_id = '470ae9e8205d8dc9a077eda90ba0ae32bd5641a321ba28fc643ab52702098ad3'
AND (
token = 'xuZXagEc38/RXluAmfPIYFQU9GtY8RcQjD3bf5gz0gg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)