UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rE0DTo2sZ10NfHAK8hjZl/S/fHgl3fbieHt++hGExR4='
WHERE
key_id = '38c6e0b5d296c4f2ca6804eed4be9f0d7476b04afa81ad4e18444d6a921564a8'
AND (
token = 'rE0DTo2sZ10NfHAK8hjZl/S/fHgl3fbieHt++hGExR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)