UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BF9/KNr0ThehBxkTGunbCd4VxvYeNYN7yeDmvvWu9Pk='
WHERE
key_id = 'c6c354f53591adde99f6e19c4871084e4ea44de0fba87a2dfb37c94980af3610'
AND (
token = 'BF9/KNr0ThehBxkTGunbCd4VxvYeNYN7yeDmvvWu9Pk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)