UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g6Uz+uA0UDuf33CMQUrHMQvBGCGoGdUO+12XJq/yLUo='
WHERE
key_id = '2037f6c04cc341d40018625c220287e15d2864f07793f648d61e18fbec3522ca'
AND (
token = 'g6Uz+uA0UDuf33CMQUrHMQvBGCGoGdUO+12XJq/yLUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)