UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y2QRugBdEDNyNpwqiq7NR5r9G5mcnkArUyF6MHq15Xw='
WHERE
key_id = 'fe29bdd0d383b993243c9e2fdf192b7678d210909aac4a195464ea735c8e14d6'
AND (
token = 'Y2QRugBdEDNyNpwqiq7NR5r9G5mcnkArUyF6MHq15Xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)