UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VXYQXXGP7WzXBGV+w4D8lJNO8y1B6iWzeM0bDvohXi0='
WHERE
key_id = '786834075bd43e8c5071c4dd53093c599bca3054023a13683dc48172362e2246'
AND (
token = 'VXYQXXGP7WzXBGV+w4D8lJNO8y1B6iWzeM0bDvohXi0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)