UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/X3RYcBCncmlF7o/jJ470fPPmnXp4SIjtzWSCEkPZnI='
WHERE
key_id = '1c54de49e6f7d7d097740b9d6499317105e373004b9c293b75e12f707904c5c6'
AND (
token = '/X3RYcBCncmlF7o/jJ470fPPmnXp4SIjtzWSCEkPZnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)