UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nL+as3jCv8NFy/bKm+8hTWq8/0k8r9HBPE6duw00O9E='
WHERE
key_id = '704c8a90fc8469c0ffeb2968be503746b0355f570d2fe371eb0bac79fceae7ae'
AND (
token = 'nL+as3jCv8NFy/bKm+8hTWq8/0k8r9HBPE6duw00O9E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)