UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rK5jPokKSwWaR1Qz38I8/GzlbkmzVlET/UzbtIdmMRA='
WHERE
key_id = 'c396e21a4e50ef7af4c5d6eddc9611bed283249ba05d23e5b1f1c90735743bdc'
AND (
token = 'rK5jPokKSwWaR1Qz38I8/GzlbkmzVlET/UzbtIdmMRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)