UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sgg0uiwmiKp5vuXksyfDBZelnp/d6/bOFElBm4nhyko='
WHERE
key_id = 'acee3e29dca49222dab62edd206ebae03caacf1409dfa5f8fa5f4c64f6802a2a'
AND (
token = 'sgg0uiwmiKp5vuXksyfDBZelnp/d6/bOFElBm4nhyko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)