UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rZDs08dMjZYbtuOIQoVyJm59ECZyYMPjukM9VCA/vEo='
WHERE
key_id = '7e5930bd87c33ef10ec5b516c7eeee8140ca9d876b2f273717a64a38de204970'
AND (
token = 'rZDs08dMjZYbtuOIQoVyJm59ECZyYMPjukM9VCA/vEo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)