UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SwhTzGfMVrtaa8DHD8GzmYXpGW50gJqms0j09NR1lME='
WHERE
key_id = '9ccd658cafad4c53c7e7c7fe63679745908461554a1676c9d3896d90a9eaa32a'
AND (
token = 'SwhTzGfMVrtaa8DHD8GzmYXpGW50gJqms0j09NR1lME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)