UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+pVJODn7Vc7zbk3oxEd2PAOlB6C7czIUginYM8lFmkU='
WHERE
key_id = '964b5690520ea39524ec1d462b70802abb3ba674d26e5f79b32f83ca795b77d4'
AND (
token = '+pVJODn7Vc7zbk3oxEd2PAOlB6C7czIUginYM8lFmkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)