UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SMRXzocdyPr1reOXl1spQmxRJ/SJVHfRe9F7pu06zWw='
WHERE
key_id = '3c5ca9805f782616ab2669dea07e5a38a8fa7e9c215f4e5c81147238a5595c5e'
AND (
token = 'SMRXzocdyPr1reOXl1spQmxRJ/SJVHfRe9F7pu06zWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)