UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0TiVC6NlQF2zqi4F7bRqU7shhtTAWq+5COoU8kBUQDk='
WHERE
key_id = '411b0b327b8e873c05ae17d486ae30fc22fc6b53c2840ee8f598ee2e5c60f2ca'
AND (
token = '0TiVC6NlQF2zqi4F7bRqU7shhtTAWq+5COoU8kBUQDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)