UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XF1eiRG5eW2ma+EiyBko409CtaEFV2CaA7tFfkTjJI='
WHERE
key_id = '18df17c66ea7bb2f3d3b5b7b43d775b28f3a5be47ea826925712a8364696de8a'
AND (
token = '6XF1eiRG5eW2ma+EiyBko409CtaEFV2CaA7tFfkTjJI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)