UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+zHfqu3oU71pNHtYdzDYla3BWY+nYyRydmzbb+h6aUE='
WHERE
key_id = '392beb2dd3301e9ca7b719d9e230fc911547c5313212dd026a18197c17cb562e'
AND (
token = '+zHfqu3oU71pNHtYdzDYla3BWY+nYyRydmzbb+h6aUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)