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