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