UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yYcYfel8rX26SVaPFK3jHi9TRnPXs5XN4Aphk4QJRLo='
WHERE
key_id = '6e24b09383f9d3297b62503a1511b225c4a1445d080672b646ce0d50775f4548'
AND (
token = 'yYcYfel8rX26SVaPFK3jHi9TRnPXs5XN4Aphk4QJRLo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)