UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xNNy6JFh1s+8UUsP7DkvQZcskpGXa5S1TBPn5PlTs4w='
WHERE
key_id = '1570c1019a292790d847bd805417b8f6db69d911e98176b4023518bcf81fde39'
AND (
token = 'xNNy6JFh1s+8UUsP7DkvQZcskpGXa5S1TBPn5PlTs4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)