UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gFhDZ/Xz9xLAy4J2rj77yAy9y8Jg0YE9tyND5c2XyYE='
WHERE
key_id = 'a3a4927e792e0b766c24fe9df744ee461c6373299e2fe53bec2622f657adfe8a'
AND (
token = 'gFhDZ/Xz9xLAy4J2rj77yAy9y8Jg0YE9tyND5c2XyYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)