UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1RtdDh1EpOHrirfVy3iBIh8jxjRn6nv9z+v/viKOtQI='
WHERE
key_id = 'f4c52692103bb361eb37f33a9b92df99881cfec220df0a31c7d6298da10a6ddf'
AND (
token = '1RtdDh1EpOHrirfVy3iBIh8jxjRn6nv9z+v/viKOtQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)