UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'huI6vzS73SNvZPtxYoWMpNEfLYqIqJwoM69Apr+nsoo='
WHERE
key_id = 'a792e34e136fa4f1c91c7a00d726358692bb0c58d642909b74e6e26f3646d4af'
AND (
token = 'huI6vzS73SNvZPtxYoWMpNEfLYqIqJwoM69Apr+nsoo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)