UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'My62AexbchVx/ZxdNS5dHB5haqGt+l751uBCCBiPHUg='
WHERE
key_id = '0b74399bf325bb672627eada39e35ba92bb57d05ec9bb5bd39dc147ec606df55'
AND (
token = 'My62AexbchVx/ZxdNS5dHB5haqGt+l751uBCCBiPHUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)